<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@ taglib uri="http://ckeditor.com" prefix="ckeditor" %>

<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

//database connection parameters
Connection connection = null;
Statement statement = null;
ResultSet result = null;
String sql = null;

String driver = "org.h2.Driver";
String url = "jdbc:h2:~/adolfmc-blog";
String name = "sa";
String password  = "";

// 
String exectype = request.getParameter("type");

try{
	Class.forName(driver);
	connection = DriverManager.getConnection(url,name,password);
	statement = connection.createStatement();
	
	Date date = Calendar.getInstance().getTime();
	SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd HH:mm:ss");
	sdf.format(Calendar.getInstance().getTime());

	sql = "select * from blog_info ";
	result = statement.executeQuery(sql);
	out.println("date -----> result rows is  :"+result==null?null:result.getRow());
	out.println(result);
}catch(Exception ex){
	ex.printStackTrace();
}

%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- saved from url=(0032)http://adolfcc.blogbus.com/logs/ -->
<html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>2012 - 达摩克利斯之剑 - 博客大巴</title>

<link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://adolfcc.blogbus.com/index.rdf">
<link href="../css/50032.css" rel="stylesheet" type="text/css">
<script>if (top.location != self.location) {top.location=self.location;}</script><script src="../script/jquery.js"></script><link rel="stylesheet" href="../css/picobox.css" type="text/css"><link rel="stylesheet" href="../css/picobox_beauty.css" type="text/css"><script type="text/javascript" src="../script/picobox.js"></script><script type="text/javascript" src="../script/picobox_beauty.js"></script><script type="text/javascript" src="../script/resize.js"></script></head><body>
<div id="index">
	<div id="container">
		<div id="header">
			<h1 class="blogName"><a href="http://adolfcc.blogbus.com/" title="http://adolfcc.blogbus.com">达摩克利斯之剑</a></h1>
			<div class="description"></div>
			<div class="clear"></div>
		</div>
       <div id="innerContainer">
           <div class="innerTop"></div>
            <div id="outerContent">
                <div id="content">
                    <div class="contentTop"></div>
                                                <ul id="posts">
                            <div class="postsTop"></div>
                            
<%
while(result.next()){
%>
                            <li>
                                <div class="postHeader">
                                    <h3></h3>
                                    <h2><a href="http://adolfcc.blogbus.com/logs/2012/01/">达摩克利斯之剑&nbsp;&nbsp;&nbsp;2012年01月</a></h2>
                                </div>
                                <div class="postBody">
                                    <a href="info.jsp?bid=<%=result.getString("id") %>"><%=result.getString("title") %></a> - 2012-01-30 15:53:00<br>
                                    <div class="clear"></div>
                                </div>
                                <div class="postFooter">
                                    <div class="tags">Tag：</div>
                                    <div class="menubar"><span class="author"><a href="http://home.blogbus.com/profile/adolfcc">adolfcc</a></span> 发表于<span class="time"> 2012年1月</span> | </div>
                                </div>
                            </li>
<%	
}

%>
                            
<script type="text/javascript">var post_ids='';</script>
                            <div class="postsBottom"></div>
                        </ul>
                        <div class="pageNavi"><a href="http://adolfcc.blogbus.com/logs/2012/">2012</a>&nbsp;&nbsp;</div>
                    <div class="contentBottom"></div>                    
                </div>
            </div>
            <div id="outerSidebar">
                <div id="sidebar">
                    <div class="sideTop"></div>
                        <div id="profile" class="module"><div class="modTop"></div><h2>个人资料</h2><div class="modBody">
<a href="http://home.blogbus.com/profile/adolfcc" target="_blank"><img class="avatar" src="../image/avatar_11722396_96.jpg"></a>
<h3 class="author"><a href="http://home.blogbus.com/profile/adolfcc" target="_blank">adolfcc</a></h3>
<div class="about"></div><div class="clear"></div></div><div class="modBottom"></div></div>
<div id="calendar" class="module">
	<div class="modTop"></div>
	<h2>日历</h2>
	<div class="modBody">
		<script type="text/javascript">var _blogid=6434953;var iCY=2012;var iCM=01;var iCD=31;var iCS=false;var sDCP = "";var sDCN = "";var LDWD = new Array();LDWD.y2012 = new Array(1);
LDWD.y2012.m1 = '30';
</script><script src="../script/calendar2.js"></script><table cellspacing="0">
<tbody><tr class="calendarHead"><td colspan="7"><span class="preMonth"><a href="http://adolfcc.blogbus.com/logs/2011/12/">«</a></span>&nbsp;2012年&nbsp;1月&nbsp;<span class="nextMonth"><a href="http://adolfcc.blogbus.com/logs/2012/2/">»</a></span></td></tr>
<tr class="week"><td class="d0">日</td><td class="d1">一</td><td class="d2">二</td><td class="d3">三</td><td class="d4">四</td><td class="d5">五</td><td class="d6">六</td></tr>
<tr class="day"><td>1</td><td>2</td><td>3</td><td>4</td><td>5</td><td>6</td><td>7</td></tr>
<tr class="day"><td>8</td><td>9</td><td>10</td><td>11</td><td>12</td><td>13</td><td>14</td></tr>
<tr class="day"><td>15</td><td>16</td><td>17</td><td>18</td><td>19</td><td>20</td><td>21</td></tr>
<tr class="day"><td>22</td><td>23</td><td>24</td><td>25</td><td>26</td><td>27</td><td>28</td></tr>
<tr class="day"><td>29</td><td><a href="http://adolfcc.blogbus.com/logs/2012/01/d30.html"><b>30</b></a></td><td class="today">31</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr></tbody></table></div>
	<div class="modBottom"></div>
</div><div id="search" class="module">
	<div class="modTop"></div>
	<h2>搜索</h2>
	<div class="modBody">
		<form name="SearchForm" method="get" target="_blank" action="http://search.blogbus.com/search">
			<input type="text" name="q" class="textField">
			<input type="submit" class="button" value="搜索">
			<input type="hidden" name="b" value="6434953">
			<input type="hidden" name="dir" value="oneblog">
			<div class="clear"></div>
		</form>
	</div>
	<div class="modBottom"></div>
</div><div id="login" class="module">
<div class="modTop"></div>
<h2>管理</h2>
<div class="modBody">
<ul>
<li><span class="admin"><a href="http://www.blogbus.com/user/" target="_blank">进入后台</a></span>
<span class="write"><a href="http://blog.home.blogbus.com/6434953/posts/form" target="_blank">写新日志</a></span></li>
<li><span class="posts"><a href="http://blog.home.blogbus.com/6434953/posts/" target="_blank">文章管理</a></span>
<span class="cmts"><a href="http://blog.home.blogbus.com/6434953/comments/items" target="_blank">评论管理</a></span></li>
<li><span class="skins"><a href="http://blog.home.blogbus.com/6434953/skins/blogbus_public_skins" target="_blank">更换模板</a></span>
<span class="stats"><a href="http://blog.home.blogbus.com/stat" target="_blank">访问统计</a></span></li>
</ul>
</div>
<div class="modBottom"></div>
</div><div id="cats" class="module">
	<div class="modTop"></div>
	<h2>文章分类</h2>
	<div class="modBody">
		<ul><li><a href="http://adolfcc.blogbus.com/c4167878/">是非得失sdf5<span class="count">[0]</span></a></li>
<li><a href="http://adolfcc.blogbus.com/c4167877/">是非得失sdf4<span class="count">[0]</span></a></li>
<li><a href="http://adolfcc.blogbus.com/c4167876/">是非得失sdf3<span class="count">[0]</span></a></li>
<li><a href="http://adolfcc.blogbus.com/c4167875/">是非得失sdf2<span class="count">[0]</span></a></li>
<li><a href="http://adolfcc.blogbus.com/c4167874/">是非得失sdf<span class="count">[0]</span></a></li>
<li><a href="http://adolfcc.blogbus.com/c4167656/">t<span class="count">[3]</span></a></li>
</ul>
	</div>
	<div class="modBottom"></div>
</div><div id="tags" class="module">
	<div class="modTop"></div>
	<h2>Tag</h2>
	<div class="modBody">
		<ul></ul>
		<div class="more"><a href="http://adolfcc.blogbus.com/tags/">More..</a></div>
	</div>
	<div class="modBottom"></div>
</div><div id="nPosts" class="module">
	<div class="modTop"></div>
	<h2>最新文章</h2>
	<div class="modBody">
		<ul>
<%
while(result.next()){
	
%>
<li><a href="info.jsp?bid=<%=result.getString("id") %>"><%=result.getString("title") %></a></li>
<%	
}

%>		
</ul>
		<div class="more"><a href="./list.htm">全部日志&gt;&gt;</a></div>
	</div>
	<div class="modBottom"></div>
</div><div id="nComments" class="module">
	<div class="modTop"></div>
	<h2>最新评论</h2>
	<div class="modBody">
		<ul><li><span class="author"><a href="http://s/" target="_blank">sd</a></span>：<a href="http://adolfcc.blogbus.com/logs/189601909.html#cmt">sdf</a></li><li><span class="author"><a href="http://adolfcc.blogbus.com/" target="_blank">adolfcc</a></span>：<a href="http://adolfcc.blogbus.com/logs/189601909.html#cmt">sss</a></li></ul>
	</div>
	<div class="modBottom"></div>
</div><div id="links" class="module">
	<div class="modTop"></div>
	<h2>链接</h2>
	<div class="modBody">
		<ul></ul>
	</div>
	<div class="modBottom"></div>
</div><div id="archives" class="module">
	<div class="modTop"></div>
	<h2>存档</h2>
	<div class="modBody">
		<ul></ul>
	</div>
	<div class="modBottom"></div>
</div>
<div id="custom"></div>
                        <div id="meta" class="module">
                            <div class="modTop"></div>
                            <div class="modBody">
                                <ul>
                                    <li class="statistics">访问统计：<span class="count"><script src="../script/counter_show.js.php"></script><script src="../script/counter_more.php"></script>49</span></li>
                                    <li class="subscribe" style="line-height:180%;"><div><a href="http://adolfcc.blogbus.com/index.rdf"><img src="../image/rss.gif" alt="RSS"></a> <a href="http://bangzhuzhongxin.blogbus.com/logs/5452786.html" target="_blank">什么是RSS？</a></div><div class="inezha" style="margin:.5em 0"><a href="http://inezha.com/add2?hid=2320&url=http://adolfcc.blogbus.com/index.rdf" title="此博客内容更新用IM提醒我" target="_blank"><img src="../image/anothr.gif" alt="用IM提醒我内容更新"></a></div><div class="qqmail" style="margin:.5em 0"><a href="http://mail.qq.com/cgi-bin/feed?u=http://adolfcc.blogbus.com/index.rdf" title="订阅到QQ邮箱" target="_blank"><img src="../image/qqmail.png" alt="订阅到QQ邮箱"></a></div><div class="xiangguo" style="margin:.5em 0"><a href="http://www.xianguo.com/subscribe.php?url=http://adolfcc.blogbus.com/index.rdf" title="订阅到鲜果阅读器" target="_blank"><img src="../image/xianguo.png" alt="订阅到鲜果阅读器"></a></div><div class="g-reader" style="margin:.5em 0"><a href="http://fusion.google.com/add?feedurl=http://adolfcc.blogbus.com/index.rdf" title="订阅到Google阅读器" target="_blank"><img src="../image/google.png" alt="订阅到Google阅读器"></a></div><div class="zhuaxia" style="margin:.5em 0"><a href="http://www.zhuaxia.com/add_channel.php?url=http://adolfcc.blogbus.com/index.rdf" title="订阅到抓虾阅读器" target="_blank"><img src="../image/zhuaxia.png" alt="订阅到抓虾阅读器"></a></div></li>
                                    <li class="poweredBy">
                                        <a href="http://www.icity.cn/catalog" target="_blank" class="iCityLogo" style="background:none;"><img src="../image/icity_cover_200908.jpg" alt="《城客》第四期：创意之城" style="margin-bottom:5px;"></a><br><a href="http://www.blogbus.com/" target="_blank"><img src="../image/link_blogbus.gif" alt="博客大巴"></a><div><a href="http://bangzhuzhongxin.blogbus.com/" target="_blank" title="博客大巴使用指南">博客大巴使用指南</a></div><div><a href="http://www.blogbus.com/skin/" target="_blank" title="博客大巴模板中心">博客大巴模板中心</a></div><div><a href="http://passport.blogbus.com/register_form" target="_blank" title="免费注册博客大巴">免费注册博客大巴</a></div><div><a href="http://banjia.blogbus.com/" target="_blank" title="一键博客搬家工具">一键博客搬家工具</a></div><div><a href="http://www.icity.cn/" target="_blank" title="中文互动杂志城客">中文互动杂志城客</a></div>
                                    </li>
                                </ul>
                            </div>
                            <div class="modBottom"></div>
                        </div>
                    <div class="sideBottom"></div>
                </div>
            </div>
            <div class="innerBottom"></div>
        </div>        
		<div class="clear"></div>
		<div id="footer">
	<div class="copyright">Copyright © 2002-2012 BlogBus.com, All Rights Reserved. <a href="http://www.blogbus.com/" target="_blank">博客大巴</a> 版权所有
<br><a href="http://new-skin032.blogbus.com/">博客大巴模板设计：简约风格2 | 作者： innocent_sin</a>
</div>
		</div>
	</div>
</div><script type="text/javascript">
//<![CDATA[
ac_as_id = 71172;
ac_click_track_url = "";ac_format = 0;ac_mode = 1;
ac_width = 280;ac_height = 210;
//]]>
</script>
<span style="position: absolute; left: 0px; top: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; background-position: initial initial; background-repeat: initial initial; "><embed type="application/x-shockwave-flash" src="http://static.acs86.com/FrameWork/system/afc.swf" id="ac_oe86_161803399" width="1" height="1" wmode="transparent" allowscriptaccess="always" flashvars="q"></span><script id="ac_js86_71172"></script><script type="text/javascript" src="../script/g.js"></script><script type="text/javascript" src="../script/helper1.js"></script><script type="text/javascript">
        var gaJsHost = (("https:" == document.location.protocol)?"https://ssl." : "http://www.");
        document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
        </script><script src="../script/ga.js" type="text/javascript"></script>
        <script type="text/javascript">
        var pageTracker = _gat._getTracker("UA-2120146-1");
        pageTracker._setDomainName(".blogbus.com");
        pageTracker._addOrganic("baidu","word");
        pageTracker._addOrganic("baidu","wd");
        pageTracker._addOrganic("soso","w");
        pageTracker._addOrganic("vnet","kw");
        pageTracker._initData();
        pageTracker._trackPageview();
        </script>
	<script type="text/javascript" src="../script/checkSpam.js"></script><div id="picoboxMask" style="height: 800px; width: 1280px; "></div><div id="picobox" style="display:none;"><table style="width:100%;height:100%" cellspacing="0" cellpadding="0"><tbody><tr><td class="rc_lt"></td><td class="top"></td><td class="rc_rt"></td></tr><tr><td class="left"></td><td class="content"><div id="picoboxInner"><h1 class="picoboxTitle"><div><span></span><a href="http://adolfcc.blogbus.com/logs/#" onclick="Picobox.hide();return false;" class="close">X</a></div></h1><div class="picoboxBody"></div></div></td><td class="right"></td></tr><tr><td class="rc_lb"></td><td class="bottom"></td><td class="rc_rb"></td></tr></tbody></table></div></body>
<% 
try{
result.close();
statement.close();
connection.close();
}catch(Exception ex){
	ex.printStackTrace();
}
%>	
	</html>